//
//  LCDBSql.h
//  ISFMDB
//
//  Created by admin on 2017/6/27.
//  Copyright © 2017年 IS. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "LCDBDefine.h"

@interface LCDBSql : NSObject

//alterEssayTable
//对原有数据库数据表 EssayTable 进行升级增加字段 UserThirdpartyAuthkey 插入列
//#define ALTER_USERINFOTABLE_USERTHIRDPARTYAUTHKEY @"ALTER TABLE UserInfoTable ADD UserThirdpartyAuthkey text"

//alterEssayTable
//对原有数据库数据表 EssayTable 进行升级增加字段 cid 插入列
#define ALTER_ESSAYTABLE_CID  @"ALTER TABLE EssayTable ADD cid text"
#define ALTER_ESSAYTABLE_SRC  @"ALTER TABLE EssayTable ADD src text"

///创建云头条的数据库表
#define CREATE_ESSAYTABLE @"CREATE TABLE if not exists EssayTable (tid integer primary key autoincrement, \
                                            id text, \
                                            cid text, \
                                            title text, \
                                            src text, \
                                            pv text, \
                                            timestamp text, \
                                            url text, \
                                            image30 text, \
                                            image31 text, \
                                            image32 text, \
                                            read_history integer  )"
//pv不用


@end
